Dudley — Network Review

Dudley — Network Review

4877 total sections in ARs "hierarchies final" spreadsheet
372 (classified) and 4449 (unclassified) = 4821 total sections from DBs spreadsheets
4878 total sections in DBs map layer

DBs classified map layer doesn't contain USRN
DBs unclassified map layer does contain USRN
Map of exising network (green), gazetteer additions (red) and PRoW additions (amber)

1. Match AR spreadsheet with DBs map layer

Two sections in map that were not in AR:

symlink section_rf
3115   DUD3221/01
3785   DUD4404/01

However there are 16 sections in both DBs map and ARs spreadsheet that have no section reference or road name (same symlinks).

Using the map as the base layer...

2. Fill in missing road names:

symlink roadname
2671   WALTON COURT FROM ENTRANCE ANTICLOCKWISE
2640   DUPLICATE OF FURNACE LANE
4240   HORACE STREET (DUPLICATE)
1819   LOCKFIELD CLOSE
2159   ROGUE EXTENSION OF BELL STREET SOUTH
2448   IMPERIAL WORKS (BROMLEY STREET) - PRIVATE
2447   BROMLEY STREET (PARTIAL)
2530   FOOTPATH BETWEEN 105 AND 185 APPERLEY WAY AND
2532   FOOTPATH FROM 53 APPERLEY WAY TO WILTSHIRE DRIVE
2531   FOOTPATH FROM 85 APPERLEY WAY TO WILTSHIRE DRIVE
2670   WALTON COURT FROM HIGH FARM ROAD TO COURT
4700   VICTORIA ROAD
3048   MERES ROAD (PRIVATE ACCESS ROAD)
4011   FOOTPATH FROM VAUXHALL ROAD TO MOUNT ROAD (NOT IN GAZETTEER)
4869   ST AMBROSE CLOSE (PRIVATE)
2863   LAPAL LANE SOUTH (DUPLICATE)

The above sections all need review in Symology to either remove where duplicate/private or identify the section reference where valid.

3. Fill in USRNs in DBs map:

The DB unclassified file had USRNs so these can be added via the symlink. Results in 4394 of 4878 USRNs assigned.
The DB classified file does not contain USRNs, hence we need to populate these fist in the classified file before updating DB's map layer. This is done by creating a combination of number/name and in both the DB classifieds and the gazetteer and performing a join. Failed joins (i.e. single name, multiple numbers) are then manuall assigned.

Issues found were:

Item Issue
A458E/A/B/C (BATH ROAD)The route number A458 is not related to Bath Road (only A451)
DUD4580/01 (FOSTER STREET EAST)The route number states A458, but its the C4580
A458F (ST JOHNS ROAD)The route number A458 is not related to St Johns Road (only A491)
A458H/B (NEW ROAD)The route number is both the reference (A458) and stated route (A491) conflicts with gazetteer (A451)
B4171B (WADDAM'S POOL)is not classified according to gazetteer
B4177F (ST JAMES'S ROAD)is not classified according to gazetteer
B4177E (TRINITY ROAD)is not classified according to gazetteer
B4483D/E (CASTLE STREET)is not classified according to gazetteer

On unclassifieds, issues:

Item Issue
DUD4852/01 (COVERS BOTH GUARDIANS WALK AND KIRKPATRICK DRIVE - NEEDS SPLITTING) 

Majority were populated by lookup, remainder have been manually assigned (where road names are missing/incorrectly spelt etc.)

Final dataset cross-referenced against gazetteer leaves 27 records conflicting (i.e. the USRN does not exist in the gazetteer). This is due to no USRN (i.e. the 17 missing road name sections) and 10 with rogue USRNs (i.e. USRNs identified in the DB unclassified list that do not exist). Manually correcting these:

symlink section_rf USRN (old) USRN (new)
5598DUD3058/021140774511403606
83DUD0069/011140760011404914
4284DUD1130/011140763211405560
392DUD0345/011140529011404377
1739DUD1483/0111400707-1 (rogue section)
5474DUD1674/031140061611406173
3185DUD3277/011140774511406151
4815DUD4111/011140774511407755
4799DUD0809/021140000011404572 (non-gazetteer branch off Nith Place)
4802DUD0456/0111404537-1 (rogue section)
2938DUD3058/011140774511403606

4. Cross-Reference network USRNs with Gazetteer USRNs

symlink USRN Issue
-11400071CAWNEY HILL MISSING FROM NETWORK
1097TETNALL STREET CONSUMES CONSTITUTION HILL EAST (NEED SEPARATING)
4390COLLEY LANE CONSUMES BRIDGE STREET (NEED SEPARATING)
-11400125GARDEN WALK MISSING FROM NETWORK
1610BROMLEY LANE CONSUMES BROMLEY (NEED SEPARATING)
-11400142GOULDS LANE MISSING FROM NETWORK
4393MAYPOLE HILL CONSUMES CRADLEY FORGE (NEED SEPARATING)
-11400332GIBBONS LANE MISSING FROM NETWORK
-11400355HALL LANE MISSING FROM NETWORK
4408COMMONSIDE CONSUMES HIGH OAK (NEED SEPARATING AND SPLITTING)
-11400403PHOENIX PASSAGE MISSING FROM NETWORK
-11400405THE CLIFF MISSING FROM NETWORK
-11400408SANDFIELD BRIDGE CONSUMED WITHIN CINDER ROAD AND STALLINGS LANE (NEED SEPARATING)
4410BRIERLEY HILL ROAD CONSUMES LEY'S ROAD (NEED SEPARATING)
-11400544MILL STREET MISSING FROM NETWORK
4392PARK LANE CONSUMES NETHEREND LANE (NEED SEPARATING)
4350BROMSGROVE ROAD CONSUMES BROMSGROVE STREET (NEED SEPARATING)
4553FURNACE LANE CONSUMES FURNACE HILL (NEED SEPARATING)
2811UFFMOOR ESTATE HAD INCORRECTLY ASSIGNED USRN, ALSO MISSING SECTION
-11401756BIRCH DRIVE MISSING FROM NETWORK
4484GORSTY HILL ROAD CONSUMES HALESOWEN STREET (NEED SEPARATING)
4377HIGH STREET CONSUMES MARKET STREET (NEED SEPARATING)
-11402404SPRINGFIELD LANE MISSING FROM NETWORK
4463AUDNAM IS HIGH STREET IN GAZETTEER (REVIEW)
4312DUDLEY ROAD CONSUMES HIGH STREET (NEED SEPARATING)
-11402997RECTORY FIELDS MISSING FROM NETWORK
-11403288NEW STREET MISSING FROM NETWORK
4341WINDMILL HILL CONSUMES COLLEY GATE (NEED SEPARATING)
4342STOURBRIDGE ROAD CONSUMES DREWS HOLLOWAY (NEED SEPARATING)
4418BROOK ROAD CONSUMES GLASSHOUSE HILL (NEED SEPARATING)
4306PEDMORE ROAD CONSUMES GRANGE LANE (NEED SEPARATING)
4340PARK ROAD / THE HAYES NEEDS SEPARATING
-11404000BIRDCAGE WALK MISSING FROM NETWORK
4398ZOAR STREET CONSUMES CHURCH STREET (NEED SEPARATING)
4362KENT STREET CONSUMES CLARENCE STREET (NEED SEPARATING)
4362KENT STREET CONSUMES DUDLEY ROAD (NEED SEPARATING)
4423TUNNEL STREET CONSUMES FULLWOODS END (NEED SEPARATING)
-11404303GATEHOUSE FOLD MISSING FROM NETWORK
4373GOSPEL END ROAD CONSUMES GOSPEL END STREET (NEED SEPARATING)
1369GRANGE ROAD INCORRECTLY ASSIGNED USRN
4383DAISY STREET CONSUMES HARDING STREET (NEED SEPARATING)
4398ZOAR STREET CONSUMES TEMPLE STREET (NEED SEPARATING)
-11405281ASHENHURST WALK MISSING FROM NETWORK
-11405344COALBOURN WAY MISSING FROM NETWORK
-11405350CRADLEY MILL MISSING FROM NETWORK
-11405414GREEN MAN ENTRY MISSING FROM NETWORK
-11405470LAUREL CLOSE MISSING FROM NETWORK
-11405473LEVESON WALK MISSING FROM NETWORK
1311PINEWOOD WALK INCORRECTLY ASSIGNED USRN
-11405549QUEEN STREET PASSAGE MISSING FROM NETWORK
-11405559ROPER WALK MISSING FROM NETWORK
-11405570RYEMARKET MISSING FROM NETWORK
-11405591SIX FOOT ROAD MISSING FROM NETWORK
-11405610ST LUKES TERRACE MISSING FROM NETWORK
-11405631SWEET TURF MISSING FROM NETWORK
-11405678LEYS ROAD ACCESS TO INDUSTRIAL ESTATES AND PUBLIC OPEN SPACE MISSING FROM NETWORK
-11405745BROOMEHILL CLOSE FOOTPATH TO BEAUMONT DRIVE MISSING FROM NETWORK
-11405768FOOTPATH BETWEEN ALBERT STREET AND MILTON STREET MISSING FROM NETWORK
-11406070COWDREY CLOSE MISSING FROM NETWORK
-11406075THE BREEZE MISSING FROM NETWORK
-11406089ALDENEY CLOSE MISSING FROM NETWORK
-11406099CHARLES HAYWARD DRIVE MISSING FROM NETWORK
-11406139WHARF MEWS MISSING FROM NETWORK
-11406162NASH GARDENS MISSING FROM NETWORK
-11406168REAR ACCESS FOR BARN OWL WALK AND COWSLIP WALK MISSING FROM NETWORK
-11406169HYDE MILL DRIVE MISSING FROM NETWORK
-11406178MORROW WAY MISSING FROM NETWORK
-11406180HAY BARN CLOSE MISSING FROM NETWORK
-11406186DAWN CLOSE MISSING FROM NETWORK
-11406187FUSSELL WAY MISSING FROM NETWORK
-11406188AURORA GARDENS MISSING FROM NETWORK
-11406191SANDVIK PLACE MISSING FROM NETWORK
-11406195ZOOLOGICAL DRIVE (CYCLEWAY) MISSING FROM NETWORK
-11406196FLINT GROVE MISSING FROM NETWORK
-11406209TALBOT PASSAGE MISSING FROM NETWORK
-11406221ALBERTINE MEWS MISSING FROM NETWORK
-11406223ROAD BETWEEN CHAPEL STREET AND QUEEN STREET MISSING FROM NETWORK
-11406227BLUE COAT DRIVE MISSING FROM NETWORK
-11406267PENNANT DRIVE MISSING FROM NETWORK
-11406269THATCHERS BARN DRIVE CYCLEWAY TO NARROW LANE MISSING FROM NETWORK
-11406270CYCLEWAY FROM MARSHALL CRESCENT TO CLOCK TOWER VIEW (CYCLEWAY) MISSING FROM NETWORK
-11406271CYCLEWAY FROM GUARDIANS WALK TO AUCKLAND ROAD (CYCLEWAY) MISSING FROM NETWORK
-11406285WOODMAN AVENUE MISSING FROM NETWORK
5339ROBERT STREET CONSUMES JEWS LANE (NEED SEPARATING)
-11407688WELBECK CLOSE MISSING FROM NETWORK
-11407697PEDMORE ROAD INDUSTRIAL ESTATE MISSING FROM NETWORK
-11407742BIRCHWOOD WALK MISSING FROM NETWORK
-11407754FURNACE COPPICE MISSING FROM NETWORK
-11407762MILL MEADOW MISSING FROM NETWORK
-11407763MONS HILL MISSING FROM NETWORK
-11407848RAILWHARF SIDINGS MISSING FROM NETWORK
-11408088FOOTPATH FROM LOWER VALLEY ROAD TO 390362 286677 MISSING FROM NETWORK

+ 60 more cycleways in gazetteer that are missing from the network.

Addition of the above new streets/footpaths/cycleways add an extra 20.6km (section length) to the current 1,019.5km (section length) of network (around 2%). This does not include public rights of way

5. Public Rights of Way

If PRoWs are to be included in the highway safety inspections these need to be added to the network. Dudley make their PRoW network publicly accessible from the following link:

https://maps.dudley.gov.uk/getows.ashx?mapsource=mapsources/inspire&service=WFS&language=English&version=1.1.0&request=GetFeature&typename=row_lines&f=geojson

This is a WSF feature collection using gml markup. Coded import routine to convert the data to a MapInfo table, which when filtered against prow_status (not historic) and subtype (not housing) the resulting dataset contains 1,614 PRoWs, totalling 223.8km.
The overlap of PRoW network on the gazetteer (mainly cycleways) reduces the "additional" PRoW dataset to 1,549 PRoWs, totalling 212.4km (roughly 20% of the current safety network).